Represents ADO.Net DataSet. It lets youáuse ADO.Net DataSet as source for data bindingsá(dataSrc and dataFld attributes)áon HTML page.á
ADO.Net DataSet may be initially filledá with data using Xml and XmlSchema parameters or from DBMS (SqlServer, OleDb source etc.) using AssemblyName, DataAdapterTypeName, ConnectionTypeName, ConnectionString, TABLE_XXX and RELATION_XXX parameters.
| Property | Description |
|---|---|
| DataSet | ADO.Net DataSet instance. This object is not COM-visible so its properties and methods can not be used from script directy. But ADO.Net DataSet may be passed as parameter to .Net method (for example, method of object created with ClrDomain.CreateInstance or object placed onto HTML page as ClrInstance). |
| AssemblyName | The display name of the assembly. For example, "System.Data, Version = 1.0.5000.0, PublicKeyToken = b77a5c561934e089, Culture = neutral" (without quotes). |
| DataAdapterTypeName | Full type name (with namespace) of DataAdapter object. For example, "System.Data.SqlClient.SqlDataAdapter" or "System.Data.OleDb.OleDbDataAdapter". |
| ConnectionTypeName | Full type name (with namespace) of Connection object. For example, "System.Data.SqlClient.SqlConnection" or "System.Data.OleDb.OleDbConnection". Currently this parameter is not used. |
| ConnectionString | Gets or sets the string used to open a database. |
| CommandBuilderTypeName | Full type name (with namespace) of CommandBuilder object. For example, "System.Data.SqlClient.SqlCommandBuilder" or "System.Data.OleDb.OleDbCommandBuilder". This parameter is used to with Update() method. |
| QuotePrefix | QuotePrefix for CommandBuilder. |
| QuoteSuffix | QuoteSuffix for CommandBuilder. |
| Xml | URL or file name of .xml file used to load ADO.Net DataSet. Can be relative URL, i.e. XML file can be compiled into HTML application. |
| XmlSchema | URL or file name ofá.xsd file used to load ADO.Net DataSet schema. Can be relative URL, i.e. XML schemaáfile can be compiled into HTML application. |
| Namespace | Gets or sets the namespace of the DataSet. |
| Prefix | Gets or sets an XML prefix that aliases the namespace of the DataSet. |
| ExtendedProperties[string Name] | Gets the customized user information associated with the DataSet. |
| Method | Description |
|---|---|
| FillTable(string TableName, string CommandText) | Fills ADO.Net DataSet table with data retrieved by executing command specified by CommandText. New table willábe named according TableName. |
| AddRelation(string RelationName, string ParentTable, string ParentColumns, string ChildTable, stringChildColumns) | Adds relation to ADO.Net DataSet. Columnsáshould beáseparated with comma (','). |
| HasErrors() | Gets a value indicating whether there are errors in any of the DataTable objects within this DataSet. |
| HasChanges() | Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows. |
| Update() | Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the DataSet. |
| ReadXmlFromFile(string FileName) | Reads XML schema and data into the DataSet. |
| ReadXmlSchemaFromFile(string FileName) | Reads an XML schema into the DataSet. |
| WriteXmlToFile(string FileName) | Writes XML data, and optionally the schema, from the DataSet. |
| WriteXmlSchemaToFile(string FileName) | Writes the DataSet structure as an XML schema. |
| Parameter | Description |
|---|---|
| AssemblyName | The display name of the assembly. For example, "System.Data, Version = 1.0.5000.0, PublicKeyToken = b77a5c561934e089, Culture = neutral" (without quotes). |
| DataAdapterTypeName | Full type name (with namespace) of DataAdapter object. For example, "System.Data.SqlClient.SqlDataAdapter" or "System.Data.OleDb.OleDbDataAdapter". |
| ConnectionTypeName | Full type name (with namespace) of Connection object. For example, "System.Data.SqlClient.SqlConnection" or "System.Data.OleDb.OleDbConnection". Currently this parameter is not used. |
| ConnectionString | Gets or sets the string used to open a database. |
| CommandBuilderTypeName | Full type name (with namespace) of CommandBuilder object. For example, "System.Data.SqlClient.SqlCommandBuilder" or "System.Data.OleDb.OleDbCommandBuilder". This parameter is used to with Update() method. |
| QuotePrefix | QuotePrefix for CommandBuilder. |
| QuoteSuffix | QuoteSuffix for CommandBuilder. |
| Xml | URL or file name of .xml file used to load ADO.Net DataSet. Can be relative URL, i.e. XML file can be compiled into HTML application. |
| XmlSchema | URL or file name ofá.xsd file used to load ADO.Net DataSet schema. Can be relative URL, i.e. XML schemaáfile can be compiled into HTML application. |
| TABLE_XXX | If specified, adds table with name XXX. CommandText used to fill table is in parameter value. For example, <PARAM name="TABLE_customers" value="Select * from customers"> fills table customers with data retrieved from command Select * from customers. |
| RELATION_XXX | Adds relation to ADO.Net DataSet. XXX specify relation name, value attribute is in form: "parent_table=XXX; parent_columns=XXX; child_table=XXX; child_columns=XXX" (replace XXX with valid values). Columns should be separated with comma (','). |